Styles

The same standard Styles are used in Excel, however, if you want to create a new style in order to change the format of how the numbers are displayed, see the example that follows.

Creating a Custom Style

The following example was created in the Excel 2010 Version.
On the Home Tab, click on the new style sheet.

Select New Cell Style

A new style window will appear, click Format.

The format page will then display, click Custom.

Finally, under Type, enter the custom formatting. This example will be formatting for Millions. (#,,)

Click OK.

Type in a Style Name and click OK.

Now that a new style sheet has been created in Excel, it can be assigned to a Quick view.

This is the Quick View before the formatting:

To add the formatting, click on the Edit Quick View Options in the Quick View Tab on the right side of the screen.

This is the Quick View after the update: